package com.mty.springboot.dao;

import com.mty.springboot.model.Score;
import org.apache.ibatis.annotations.Param;
import java.util.*;

/**
 * DAO层接口
 * @author: mty
 */
public interface ScoreMapper{

    //获取列表
    public List<Score> getScoreList(Map mp);

    //获取总条数
    public Integer totalCount(Map mp);

    //添加
    public int addScore(Score score);

    //删除
    public int deleteScore(@Param("id") String id);

    //修改
    public int updateScore(Score score);

    //根据ID查询
    public Score findScoreById(@Param("id") String id);

    //查询所有
    public List<Score> getAll();

    //按照条件查询
    public List<Score> queryFilter(Map mp);

    //获取积分榜
    public List<Score> queryBang();
}
